Release 10.1A: OpenEdge Data Management:
SQL Reference

RAND

Returns a randomly generated number, using expression as an optional seed value.

Syntax

RAND ( [ expression ] )

Example

This example illustrates the RAND function, supplying an optional seed value of ‘3’:

SELECT RAND(3) 'Random number using 3 as seed value' FROM MYMATH;

Note

expression must evaluate to an exact numeric data type.

Compatibility

ODBC compatible